Reporte

Dataset statistics

Number of variables	43
Number of observations	198910
Missing cells	2246072
Missing cells (%)	26.3%
Duplicate rows	100
Duplicate rows (%)	0.1%
Total size in memory	352.2 MiB
Average record size in memory	1.8 KiB

Variable types

Text	10
Numeric	13
Categorical	9
DateTime	7
Boolean	4

Alerts

`Structural Notification` has constant value "True"	Constant
`Voluntary Soft-Story Retrofit` has constant value "True"	Constant
`Fire Only Permit` has constant value "True"	Constant
`Site Permit` has constant value "True"	Constant
Dataset has 100 (0.1%) duplicate rows	Duplicates
`Estimated Cost` is highly overall correlated with `Revised Cost`	High correlation
`Existing Construction Type` is highly overall correlated with `Number of Existing Stories` and 2 other fields	High correlation
`Existing Construction Type Description` is highly overall correlated with `Proposed Construction Type` and 1 other fields	High correlation
`Existing Units` is highly overall correlated with `Proposed Units`	High correlation
`Neighborhoods - Analysis Boundaries` is highly overall correlated with `Supervisor District` and 1 other fields	High correlation
`Number of Existing Stories` is highly overall correlated with `Existing Construction Type` and 1 other fields	High correlation
`Number of Proposed Stories` is highly overall correlated with `Existing Construction Type` and 1 other fields	High correlation
`Permit Type` is highly overall correlated with `Permit Type Definition`	High correlation
`Permit Type Definition` is highly overall correlated with `Permit Type`	High correlation
`Plansets` is highly overall correlated with `Street Number Suffix`	High correlation
`Proposed Construction Type` is highly overall correlated with `Existing Construction Type Description` and 1 other fields	High correlation
`Proposed Construction Type Description` is highly overall correlated with `Existing Construction Type Description` and 1 other fields	High correlation
`Proposed Units` is highly overall correlated with `Existing Units`	High correlation
`Revised Cost` is highly overall correlated with `Estimated Cost`	High correlation
`Street Number Suffix` is highly overall correlated with `Existing Construction Type` and 1 other fields	High correlation
`Supervisor District` is highly overall correlated with `Neighborhoods - Analysis Boundaries` and 1 other fields	High correlation
`Zipcode` is highly overall correlated with `Neighborhoods - Analysis Boundaries` and 1 other fields	High correlation
`Permit Type Definition` is highly imbalanced (83.5%)	Imbalance
`Street Number Suffix` is highly imbalanced (59.2%)	Imbalance
`Street Suffix` is highly imbalanced (69.9%)	Imbalance
`Current Status` is highly imbalanced (60.4%)	Imbalance
`Existing Construction Type Description` is highly imbalanced (60.4%)	Imbalance
`Street Number Suffix` has 196694 (98.9%) missing values	Missing
`Street Suffix` has 2768 (1.4%) missing values	Missing
`Unit` has 169430 (85.2%) missing values	Missing
`Unit Suffix` has 196949 (99.0%) missing values	Missing
`Issued Date` has 14942 (7.5%) missing values	Missing
`Completed Date` has 101715 (51.1%) missing values	Missing
`First Construction Document Date` has 14948 (7.5%) missing values	Missing
`Structural Notification` has 191988 (96.5%) missing values	Missing
`Number of Existing Stories` has 42788 (21.5%) missing values	Missing
`Number of Proposed Stories` has 42871 (21.6%) missing values	Missing
`Voluntary Soft-Story Retrofit` has 198875 (> 99.9%) missing values	Missing
`Fire Only Permit` has 180082 (90.5%) missing values	Missing
`Permit Expiration Date` has 51884 (26.1%) missing values	Missing
`Estimated Cost` has 38068 (19.1%) missing values	Missing
`Revised Cost` has 6066 (3.0%) missing values	Missing
`Existing Use` has 41117 (20.7%) missing values	Missing
`Existing Units` has 51543 (25.9%) missing values	Missing
`Proposed Use` has 42441 (21.3%) missing values	Missing
`Proposed Units` has 50915 (25.6%) missing values	Missing
`Plansets` has 37311 (18.8%) missing values	Missing
`TIDF Compliance` has 198908 (> 99.9%) missing values	Missing
`Existing Construction Type` has 43369 (21.8%) missing values	Missing
`Existing Construction Type Description` has 43370 (21.8%) missing values	Missing
`Proposed Construction Type` has 43165 (21.7%) missing values	Missing
`Proposed Construction Type Description` has 43165 (21.7%) missing values	Missing
`Site Permit` has 193550 (97.3%) missing values	Missing
`Estimated Cost` is highly skewed (γ1 = 80.2643549)	Skewed
`Revised Cost` is highly skewed (γ1 = 108.7016029)	Skewed
`Plansets` is highly skewed (γ1 = 400.8420748)	Skewed
`Existing Construction Type` is highly skewed (γ1 = 35.25093762)	Skewed
`Unit` has 21411 (10.8%) zeros	Zeros
`Revised Cost` has 8514 (4.3%) zeros	Zeros
`Existing Units` has 29135 (14.6%) zeros	Zeros
`Proposed Units` has 26885 (13.5%) zeros	Zeros
`Plansets` has 63247 (31.8%) zeros	Zeros

Reproduction

Analysis started	2024-08-29 16:15:05.020351
Analysis finished	2024-08-29 16:16:09.687095
Duration	1 minute and 4.67 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Permit Number
Text

Distinct	34484
Distinct (%)	17.3%
Missing	0
Missing (%)	0.0%
Memory size	12.7 MiB

Length

Max length	11
Median length	11
Mean length	10.181952
Min length	7

Characters and Unicode

Total characters	2025292
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	31975 ?
Unique (%)	16.1%

Sample

1st row	M394467
2nd row	2.01505E+11
3rd row	M798247
4th row	2.01308E+11
5th row	2.01307E+11

Value	Count	Frequency (%)
2.01709e+11	3549	1.8%
2.01708e+11	3424	1.7%
2.01406e+11	3092	1.6%
2.01603e+11	2984	1.5%
2.01503e+11	2982	1.5%
2.01706e+11	2969	1.5%
2.01506e+11	2944	1.5%
2.01705e+11	2935	1.5%
2.01609e+11	2927	1.5%
2.01504e+11	2914	1.5%
Other values (34474)	168190	84.6%

Most occurring characters

Value	Count	Frequency (%)
1	561084	27.7%
0	304396	15.0%
2	206496	10.2%
.	161645	8.0%
E	161645	8.0%
+	161645	8.0%
7	92993	4.6%
6	71859	3.5%
4	67853	3.4%
5	64530	3.2%
Other values (4)	171146	8.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2025292	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	561084	27.7%
0	304396	15.0%
2	206496	10.2%
.	161645	8.0%
E	161645	8.0%
+	161645	8.0%
7	92993	4.6%
6	71859	3.5%
4	67853	3.4%
5	64530	3.2%
Other values (4)	171146	8.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2025292	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	561084	27.7%
0	304396	15.0%
2	206496	10.2%
.	161645	8.0%
E	161645	8.0%
+	161645	8.0%
7	92993	4.6%
6	71859	3.5%
4	67853	3.4%
5	64530	3.2%
Other values (4)	171146	8.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2025292	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	561084	27.7%
0	304396	15.0%
2	206496	10.2%
.	161645	8.0%
E	161645	8.0%
+	161645	8.0%
7	92993	4.6%
6	71859	3.5%
4	67853	3.4%
5	64530	3.2%
Other values (4)	171146	8.5%

Permit Type
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.5222865

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	8
median	8
Q3	8
95-th percentile	8
Maximum	8
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.457526
Coefficient of variation (CV)	0.19376103
Kurtosis	6.036264
Mean	7.5222865
Median Absolute Deviation (MAD)	0
Skewness	-2.79896
Sum	1496258
Variance	2.124382
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
8	178852	89.9%
3	14664	7.4%
4	2892	1.5%
2	950	0.5%
6	600	0.3%
7	511	0.3%
1	350	0.2%
5	91	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	350	0.2%
2	950	0.5%
3	14664	7.4%
4	2892	1.5%
5	91	< 0.1%
6	600	0.3%
7	511	0.3%
8	178852	89.9%

Value	Count	Frequency (%)
8	178852	89.9%
7	511	0.3%
6	600	0.3%
5	91	< 0.1%
4	2892	1.5%
3	14664	7.4%
2	950	0.5%
1	350	0.2%

Permit Type Definition
Categorical

HIGH CORRELATION IMBALANCE

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.1 MiB

otc alterations permit	178836
additions alterations or repairs	14663
sign - erect	2892
new construction wood frame	950
demolitions	600
Other values (8)	969

Length

Max length	35
Median length	22
Mean length	22.572978
Min length	11

Characters and Unicode

Total characters	4489991
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	otc alterations permit
2nd row	otc alterations permit
3rd row	otc alterations permit
4th row	otc alterations permit
5th row	otc alterations permit

Common Values

Value	Count	Frequency (%)
otc alterations permit	178836	89.9%
additions alterations or repairs	14663	7.4%
sign - erect	2892	1.5%
new construction wood frame	950	0.5%
demolitions	600	0.3%
wall or painted sign	511	0.3%
new construction	347	0.2%
grade or quarry or fill or excavate	91	< 0.1%
otc alterations permit	8	< 0.1%
otc alterations permit #	8	< 0.1%
Other values (3)	4	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
alterations	193516	31.6%
otc	178852	29.2%
permit	178852	29.2%
or	15448	2.5%
additions	14664	2.4%
repairs	14664	2.4%
sign	3403	0.6%
	2902	0.5%
erect	2892	0.5%
construction	1300	0.2%
Other values (10)	5186	0.8%

Most occurring characters

Value	Count	Frequency (%)
t	766094	17.1%
i	422865	9.4%
r	422559	9.4%
a	418696	9.3%
	412789	9.2%
o	408180	9.1%
e	396450	8.8%
s	228147	5.1%
n	216594	4.8%
l	195320	4.4%
Other values (14)	602297	13.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4489991	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	766094	17.1%
i	422865	9.4%
r	422559	9.4%
a	418696	9.3%
	412789	9.2%
o	408180	9.1%
e	396450	8.8%
s	228147	5.1%
n	216594	4.8%
l	195320	4.4%
Other values (14)	602297	13.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4489991	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	766094	17.1%
i	422865	9.4%
r	422559	9.4%
a	418696	9.3%
	412789	9.2%
o	408180	9.1%
e	396450	8.8%
s	228147	5.1%
n	216594	4.8%
l	195320	4.4%
Other values (14)	602297	13.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4489991	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	766094	17.1%
i	422865	9.4%
r	422559	9.4%
a	418696	9.3%
	412789	9.2%
o	408180	9.1%
e	396450	8.8%
s	228147	5.1%
n	216594	4.8%
l	195320	4.4%
Other values (14)	602297	13.4%

Permit Creation Date
Date

Distinct	1291
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2012-03-28 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Block
Text

Distinct	4893
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	11.5 MiB

Length

Max length	5
Median length	4
Mean length	3.7171082
Min length	1

Characters and Unicode

Total characters	739370
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	122 ?
Unique (%)	0.1%

Sample

1st row	3751
2nd row	3556
3rd row	655
4th row	4267
5th row	1518

Value	Count	Frequency (%)
3708	1195	0.6%
3735	750	0.4%
7331	680	0.3%
289	640	0.3%
3709	584	0.3%
3717	578	0.3%
3707	576	0.3%
3721	567	0.3%
3706	561	0.3%
259	554	0.3%
Other values (4883)	192225	96.6%

Most occurring characters

Value	Count	Frequency (%)
3	97524	13.2%
1	96595	13.1%
2	85374	11.5%
5	80950	10.9%
6	77737	10.5%
7	73548	9.9%
0	60818	8.2%
4	60017	8.1%
8	50674	6.9%
9	48902	6.6%
Other values (9)	7231	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	739370	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	97524	13.2%
1	96595	13.1%
2	85374	11.5%
5	80950	10.9%
6	77737	10.5%
7	73548	9.9%
0	60818	8.2%
4	60017	8.1%
8	50674	6.9%
9	48902	6.6%
Other values (9)	7231	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	739370	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	97524	13.2%
1	96595	13.1%
2	85374	11.5%
5	80950	10.9%
6	77737	10.5%
7	73548	9.9%
0	60818	8.2%
4	60017	8.1%
8	50674	6.9%
9	48902	6.6%
Other values (9)	7231	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	739370	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	97524	13.2%
1	96595	13.1%
2	85374	11.5%
5	80950	10.9%
6	77737	10.5%
7	73548	9.9%
0	60818	8.2%
4	60017	8.1%
8	50674	6.9%
9	48902	6.6%
Other values (9)	7231	1.0%

Lot
Text

Distinct	1050
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	11.2 MiB

Length

Max length	4
Median length	2
Mean length	1.9519883
Min length	1

Characters and Unicode

Total characters	388270
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	178 ?
Unique (%)	0.1%

Sample

1st row	172
2nd row	6
3rd row	61
4th row	29
5th row	37

Value	Count	Frequency (%)
1	10116	5.1%
7	5317	2.7%
2	5184	2.6%
3	5042	2.5%
6	4835	2.4%
8	4773	2.4%
9	4590	2.3%
5	4549	2.3%
4	4384	2.2%
11	4238	2.1%
Other values (1040)	145882	73.3%

Most occurring characters

Value	Count	Frequency (%)
1	80415	20.7%
2	59437	15.3%
3	43028	11.1%
0	42471	10.9%
4	33218	8.6%
5	26863	6.9%
6	25008	6.4%
7	22210	5.7%
8	20304	5.2%
9	19441	5.0%
Other values (26)	15875	4.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	388270	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	80415	20.7%
2	59437	15.3%
3	43028	11.1%
0	42471	10.9%
4	33218	8.6%
5	26863	6.9%
6	25008	6.4%
7	22210	5.7%
8	20304	5.2%
9	19441	5.0%
Other values (26)	15875	4.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	388270	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	80415	20.7%
2	59437	15.3%
3	43028	11.1%
0	42471	10.9%
4	33218	8.6%
5	26863	6.9%
6	25008	6.4%
7	22210	5.7%
8	20304	5.2%
9	19441	5.0%
Other values (26)	15875	4.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	388270	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	80415	20.7%
2	59437	15.3%
3	43028	11.1%
0	42471	10.9%
4	33218	8.6%
5	26863	6.9%
6	25008	6.4%
7	22210	5.7%
8	20304	5.2%
9	19441	5.0%
Other values (26)	15875	4.1%

Street Number
Real number (ℝ)

Distinct	5099
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1121.7155

Minimum	0
Maximum	8400
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	32
Q1	235
median	710
Q3	1700
95-th percentile	3481
Maximum	8400
Range	8400
Interquartile range (IQR)	1465

Descriptive statistics

Standard deviation	1135.7985
Coefficient of variation (CV)	1.0125548
Kurtosis	2.1350541
Mean	1121.7155
Median Absolute Deviation (MAD)	580
Skewness	1.4269693
Sum	2.2312044 × 10⁸
Variance	1290038.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2398	1.2%
101	1153	0.6%
100	1143	0.6%
50	1103	0.6%
201	1026	0.5%
555	994	0.5%
2	814	0.4%
55	734	0.4%
350	705	0.4%
150	672	0.3%
Other values (5089)	188168	94.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	2398	1.2%
2	814	0.4%
3	309	0.2%
4	255	0.1%
5	194	0.1%
6	113	0.1%
7	132	0.1%
8	281	0.1%
9	128	0.1%

Value	Count	Frequency (%)
8400	3	< 0.1%
8331	1	< 0.1%
8325	5	< 0.1%
8320	1	< 0.1%
8300	1	< 0.1%
8245	1	< 0.1%
8231	1	< 0.1%
8228	1	< 0.1%
8222	7	< 0.1%
8219	1	< 0.1%

Street Number Suffix
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	18
Distinct (%)	0.8%
Missing	196694
Missing (%)	98.9%
Memory size	12.1 MiB

A	1501
B	291
V	228
C	56
E	28
Other values (13)	112

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2216
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	0
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	1501	0.8%
B	291	0.1%
V	228	0.1%
C	56	< 0.1%
E	28	< 0.1%
F	24	< 0.1%
G	12	< 0.1%
D	11	< 0.1%
H	11	< 0.1%
K	11	< 0.1%
Other values (8)	43	< 0.1%
(Missing)	196694	98.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	1501	67.7%
b	291	13.1%
v	228	10.3%
c	56	2.5%
e	28	1.3%
f	24	1.1%
g	12	0.5%
h	11	0.5%
k	11	0.5%
d	11	0.5%
Other values (8)	43	1.9%

Most occurring characters

Value	Count	Frequency (%)
A	1501	67.7%
B	291	13.1%
V	228	10.3%
C	56	2.5%
E	28	1.3%
F	24	1.1%
G	12	0.5%
H	11	0.5%
K	11	0.5%
D	11	0.5%
Other values (8)	43	1.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2216	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	1501	67.7%
B	291	13.1%
V	228	10.3%
C	56	2.5%
E	28	1.3%
F	24	1.1%
G	12	0.5%
H	11	0.5%
K	11	0.5%
D	11	0.5%
Other values (8)	43	1.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2216	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	1501	67.7%
B	291	13.1%
V	228	10.3%
C	56	2.5%
E	28	1.3%
F	24	1.1%
G	12	0.5%
H	11	0.5%
K	11	0.5%
D	11	0.5%
Other values (8)	43	1.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2216	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	1501	67.7%
B	291	13.1%
V	228	10.3%
C	56	2.5%
E	28	1.3%
F	24	1.1%
G	12	0.5%
H	11	0.5%
K	11	0.5%
D	11	0.5%
Other values (8)	43	1.9%

Street Name
Text

Distinct	1714
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Length

Max length	25
Median length	22
Mean length	6.5098185
Min length	3

Characters and Unicode

Total characters	1294868
Distinct characters	65
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	117 ?
Unique (%)	0.1%

Sample

1st row	03rD
2nd row	gUeRrErO
3rd row	pInE
4th row	bRyAnT
5th row	26tH

Value	Count	Frequency (%)
market	5443	2.6%
california	4587	2.2%
mission	4324	2.0%
montgomery	2933	1.4%
geary	1966	0.9%
20th	1859	0.9%
03rd	1819	0.9%
folsom	1776	0.8%
van	1698	0.8%
pine	1678	0.8%
Other values (1705)	184679	86.8%

Most occurring characters

Value	Count	Frequency (%)
A	83888	6.5%
O	63275	4.9%
e	55861	4.3%
n	55448	4.3%
r	54146	4.2%
E	54117	4.2%
t	51943	4.0%
s	49681	3.8%
R	45151	3.5%
T	42390	3.3%
Other values (55)	738968	57.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1294868	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	83888	6.5%
O	63275	4.9%
e	55861	4.3%
n	55448	4.3%
r	54146	4.2%
E	54117	4.2%
t	51943	4.0%
s	49681	3.8%
R	45151	3.5%
T	42390	3.3%
Other values (55)	738968	57.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1294868	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	83888	6.5%
O	63275	4.9%
e	55861	4.3%
n	55448	4.3%
r	54146	4.2%
E	54117	4.2%
t	51943	4.0%
s	49681	3.8%
R	45151	3.5%
T	42390	3.3%
Other values (55)	738968	57.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1294868	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	83888	6.5%
O	63275	4.9%
e	55861	4.3%
n	55448	4.3%
r	54146	4.2%
E	54117	4.2%
t	51943	4.0%
s	49681	3.8%
R	45151	3.5%
T	42390	3.3%
Other values (55)	738968	57.1%

Street Suffix
Categorical

IMBALANCE MISSING

Distinct	21
Distinct (%)	< 0.1%
Missing	2768
Missing (%)	1.4%
Memory size	11.2 MiB

St	138365
Av	43222
Bl	3555
Wy	3540
Dr	3267
Other values (16)	4193

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	392284
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	St
2nd row	St
3rd row	St
4th row	St
5th row	Av

Common Values

Value	Count	Frequency (%)
St	138365	69.6%
Av	43222	21.7%
Bl	3555	1.8%
Wy	3540	1.8%
Dr	3267	1.6%
Tr	1466	0.7%
Ct	667	0.3%
Pl	538	0.3%
Rd	389	0.2%
Ln	354	0.2%
Other values (11)	779	0.4%
(Missing)	2768	1.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
st	138365	70.5%
av	43222	22.0%
bl	3555	1.8%
wy	3540	1.8%
dr	3267	1.7%
tr	1466	0.7%
ct	667	0.3%
pl	538	0.3%
rd	389	0.2%
ln	354	0.2%
Other values (11)	779	0.4%

Most occurring characters

Value	Count	Frequency (%)
t	139032	35.4%
S	138369	35.3%
A	43305	11.0%
v	43222	11.0%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	392284	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	139032	35.4%
S	138369	35.3%
A	43305	11.0%
v	43222	11.0%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	392284	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	139032	35.4%
S	138369	35.3%
A	43305	11.0%
v	43222	11.0%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	392284	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	139032	35.4%
S	138369	35.3%
A	43305	11.0%
v	43222	11.0%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Unit
Real number (ℝ)

MISSING ZEROS

Distinct	660
Distinct (%)	2.2%
Missing	169430
Missing (%)	85.2%
Infinite	0
Infinite (%)	0.0%
Mean	78.514518

Minimum	0
Maximum	6004
Zeros	21411
Zeros (%)	10.8%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	446.1
Maximum	6004
Range	6004
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	326.9761
Coefficient of variation (CV)	4.1645304
Kurtosis	92.15637
Mean	78.514518
Median Absolute Deviation (MAD)	0
Skewness	8.1334162
Sum	2314608
Variance	106913.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21411	10.8%
1	1312	0.7%
2	549	0.3%
3	448	0.2%
101	365	0.2%
4	288	0.1%
6	214	0.1%
5	211	0.1%
201	210	0.1%
8	104	0.1%
Other values (650)	4368	2.2%
(Missing)	169430	85.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21411	10.8%
1	1312	0.7%
2	549	0.3%
3	448	0.2%
4	288	0.1%
5	211	0.1%
6	214	0.1%
7	103	0.1%
8	104	0.1%
9	69	< 0.1%

Value	Count	Frequency (%)
6004	1	< 0.1%
6003	3	< 0.1%
5903	1	< 0.1%
5604	1	< 0.1%
5602	1	< 0.1%
5413	1	< 0.1%
5412	1	< 0.1%
5313	1	< 0.1%
5312	1	< 0.1%
5306	1	< 0.1%

Unit Suffix
Text

MISSING

Distinct	163
Distinct (%)	8.3%
Missing	196949
Missing (%)	99.0%
Memory size	6.1 MiB

Length

Max length	10
Median length	1
Mean length	2.6241713
Min length	1

Characters and Unicode

Total characters	5146
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	60 ?
Unique (%)	3.1%

Sample

1st row	FRONT UNIT
2nd row	A
3rd row	FRONT UNIT
4th row	TENTATIVE
5th row	REAR BLDG

Value	Count	Frequency (%)
a	350	16.3%
c	229	10.7%
b	193	9.0%
d	137	6.4%
e	93	4.3%
bldg	93	4.3%
hoa	85	4.0%
f	78	3.6%
comml	51	2.4%
front	48	2.2%
Other values (136)	792	36.9%

Most occurring characters

Value	Count	Frequency (%)
A	551	10.7%
C	409	7.9%
E	331	6.4%
R	311	6.0%
B	309	6.0%
D	295	5.7%
O	264	5.1%
L	261	5.1%
F	208	4.0%
M	192	3.7%
Other values (38)	2015	39.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5146	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	551	10.7%
C	409	7.9%
E	331	6.4%
R	311	6.0%
B	309	6.0%
D	295	5.7%
O	264	5.1%
L	261	5.1%
F	208	4.0%
M	192	3.7%
Other values (38)	2015	39.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5146	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	551	10.7%
C	409	7.9%
E	331	6.4%
R	311	6.0%
B	309	6.0%
D	295	5.7%
O	264	5.1%
L	261	5.1%
F	208	4.0%
M	192	3.7%
Other values (38)	2015	39.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5146	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	551	10.7%
C	409	7.9%
E	331	6.4%
R	311	6.0%
B	309	6.0%
D	295	5.7%
O	264	5.1%
L	261	5.1%
F	208	4.0%
M	192	3.7%
Other values (38)	2015	39.2%

Description
Text

Distinct	134272
Distinct (%)	67.6%
Missing	290
Missing (%)	0.1%
Memory size	30.0 MiB

Length

Max length	300
Median length	243
Mean length	101.45318
Min length	1

Characters and Unicode

Total characters	20150631
Distinct characters	76
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	122032 ?
Unique (%)	61.4%

Sample

1st row	street space
2nd row	remodel (e) bathroom, convert (e) bedrm into bed room and office, all work at ground floor, comply with complaint 200452633. items 3 & 4: existing furnaces to be used.
3rd row	street space permit
4th row	comply with nov 200009226 and 200346303 remoe e non permitted shed at the rear for unit 2607a. remodel bath, kitchen, new bedroom . unit 2607: remodel bathroom, kitchen, new bedroom, and bath. new lighting and fixtures for both unit
5th row	replace 2 windows in bathroom not visible; no structural changes max u factor .40

Value	Count	Frequency (%)
	94921	3.0%
to	93338	2.9%
and	68894	2.2%
new	61786	1.9%
of	54700	1.7%
street	44273	1.4%
space	41100	1.3%
replace	36545	1.1%
in	36109	1.1%
for	35061	1.1%
Other values (109535)	2636742	82.3%

Most occurring characters

Value	Count	Frequency (%)
	3042851	15.1%
e	1735300	8.6%
o	1280056	6.4%
r	1277846	6.3%
t	1208273	6.0%
n	1153984	5.7%
a	1149599	5.7%
i	1122199	5.6%
s	828425	4.1%
l	785552	3.9%
Other values (66)	6566546	32.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20150631	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3042851	15.1%
e	1735300	8.6%
o	1280056	6.4%
r	1277846	6.3%
t	1208273	6.0%
n	1153984	5.7%
a	1149599	5.7%
i	1122199	5.6%
s	828425	4.1%
l	785552	3.9%
Other values (66)	6566546	32.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20150631	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3042851	15.1%
e	1735300	8.6%
o	1280056	6.4%
r	1277846	6.3%
t	1208273	6.0%
n	1153984	5.7%
a	1149599	5.7%
i	1122199	5.6%
s	828425	4.1%
l	785552	3.9%
Other values (66)	6566546	32.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20150631	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3042851	15.1%
e	1735300	8.6%
o	1280056	6.4%
r	1277846	6.3%
t	1208273	6.0%
n	1153984	5.7%
a	1149599	5.7%
i	1122199	5.6%
s	828425	4.1%
l	785552	3.9%
Other values (66)	6566546	32.6%

Current Status
Categorical

IMBALANCE

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.1 MiB

complete	97081
issued	83563
filed	12045
withdrawn	1754
cancelled	1536
Other values (9)	2931

Length

Max length	11
Median length	10
Mean length	6.9923282
Min length	5

Characters and Unicode

Total characters	1390844
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	issued
2nd row	complete
3rd row	issued
4th row	complete
5th row	complete

Common Values

Value	Count	Frequency (%)
complete	97081	48.8%
issued	83563	42.0%
filed	12045	6.1%
withdrawn	1754	0.9%
cancelled	1536	0.8%
expired	1370	0.7%
approved	733	0.4%
reinstated	563	0.3%
suspend	193	0.1%
revoked	50	< 0.1%
Other values (4)	22	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
complete	97081	48.8%
issued	83563	42.0%
filed	12045	6.1%
withdrawn	1754	0.9%
cancelled	1536	0.8%
expired	1370	0.7%
approved	733	0.4%
reinstated	563	0.3%
suspend	193	0.1%
revoked	50	< 0.1%
Other values (4)	22	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	297758	21.4%
s	168077	12.1%
l	112218	8.1%
d	101811	7.3%
c	100187	7.2%
p	100136	7.2%
t	99963	7.2%
i	99299	7.1%
o	97868	7.0%
m	97083	7.0%
Other values (10)	116444	8.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1390844	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	297758	21.4%
s	168077	12.1%
l	112218	8.1%
d	101811	7.3%
c	100187	7.2%
p	100136	7.2%
t	99963	7.2%
i	99299	7.1%
o	97868	7.0%
m	97083	7.0%
Other values (10)	116444	8.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1390844	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	297758	21.4%
s	168077	12.1%
l	112218	8.1%
d	101811	7.3%
c	100187	7.2%
p	100136	7.2%
t	99963	7.2%
i	99299	7.1%
o	97868	7.0%
m	97083	7.0%
Other values (10)	116444	8.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1390844	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	297758	21.4%
s	168077	12.1%
l	112218	8.1%
d	101811	7.3%
c	100187	7.2%
p	100136	7.2%
t	99963	7.2%
i	99299	7.1%
o	97868	7.0%
m	97083	7.0%
Other values (10)	116444	8.4%

Current Status Date
Date

Distinct	1307
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2019-03-02 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Filed Date
Date

Distinct	1288
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Issued Date
Date

MISSING

Distinct	1289
Distinct (%)	0.7%
Missing	14942
Missing (%)	7.5%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Completed Date
Date

MISSING

Distinct	1300
Distinct (%)	1.3%
Missing	101715
Missing (%)	51.1%
Memory size	1.5 MiB

Minimum	2013-01-04 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

First Construction Document Date
Date

MISSING

Distinct	1288
Distinct (%)	0.7%
Missing	14948
Missing (%)	7.5%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Structural Notification
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	191988
Missing (%)	96.5%
Memory size	388.6 KiB

True	6922
(Missing)	191988

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	6922	3.5%
(Missing)	191988	96.5%

Number of Existing Stories
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	64
Distinct (%)	< 0.1%
Missing	42788
Missing (%)	21.5%
Infinite	0
Infinite (%)	0.0%
Mean	5.7057077

Minimum	0
Maximum	78
Zeros	442
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	26
Maximum	78
Range	78
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	8.6133098
Coefficient of variation (CV)	1.5095953
Kurtosis	11.309873
Mean	5.7057077
Median Absolute Deviation (MAD)	1
Skewness	3.2978123
Sum	890786.5
Variance	74.189106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	52770	26.5%
3	45741	23.0%
4	16055	8.1%
1	8793	4.4%
5	3767	1.9%
6	3696	1.9%
7	2359	1.2%
8	1732	0.9%
9	1264	0.6%
10	1129	0.6%
Other values (54)	18816	9.5%
(Missing)	42788	21.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	442	0.2%
1	8793	4.4%
1.5	1	< 0.1%
2	52770	26.5%
2.5	2	< 0.1%
3	45741	23.0%
4	16055	8.1%
5	3767	1.9%
6	3696	1.9%
7	2359	1.2%

Value	Count	Frequency (%)
78	1	< 0.1%
63	99	< 0.1%
62	2	< 0.1%
61	24	< 0.1%
60	18	< 0.1%
58	93	< 0.1%
56	4	< 0.1%
55	14	< 0.1%
54	7	< 0.1%
53	12	< 0.1%

Number of Proposed Stories
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	64
Distinct (%)	< 0.1%
Missing	42871
Missing (%)	21.6%
Infinite	0
Infinite (%)	0.0%
Mean	5.7449644

Minimum	0
Maximum	78
Zeros	174
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	26
Maximum	78
Range	78
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	8.6131126
Coefficient of variation (CV)	1.4992456
Kurtosis	11.46678
Mean	5.7449644
Median Absolute Deviation (MAD)	1
Skewness	3.3179006
Sum	896438.5
Variance	74.185708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	50994	25.6%
3	46803	23.5%
4	17594	8.8%
1	7893	4.0%
5	4044	2.0%
6	3792	1.9%
7	2318	1.2%
8	1703	0.9%
9	1334	0.7%
11	1120	0.6%
Other values (54)	18444	9.3%
(Missing)	42871	21.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	174	0.1%
1	7893	4.0%
1.5	1	< 0.1%
2	50994	25.6%
2.5	2	< 0.1%
3	46803	23.5%
4	17594	8.8%
5	4044	2.0%
6	3792	1.9%
7	2318	1.2%

Value	Count	Frequency (%)
78	1	< 0.1%
63	105	0.1%
62	4	< 0.1%
61	24	< 0.1%
60	19	< 0.1%
58	90	< 0.1%
56	11	< 0.1%
55	23	< 0.1%
54	14	< 0.1%
53	12	< 0.1%

Voluntary Soft-Story Retrofit
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	2.9%
Missing	198875
Missing (%)	> 99.9%
Memory size	388.6 KiB

True	35
(Missing)	198875

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	35	< 0.1%
(Missing)	198875	> 99.9%

Fire Only Permit
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	180082
Missing (%)	90.5%
Memory size	388.6 KiB

True	18828
(Missing)	180082

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	18828	9.5%
(Missing)	180082	90.5%

Permit Expiration Date
Date

MISSING

Distinct	2232
Distinct (%)	1.5%
Missing	51884
Missing (%)	26.1%
Memory size	1.5 MiB

Minimum	2013-07-15 00:00:00
Maximum	2024-02-21 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Estimated Cost
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	11395
Distinct (%)	7.1%
Missing	38068
Missing (%)	19.1%
Infinite	0
Infinite (%)	0.0%
Mean	169009.86

Minimum	1
Maximum	5.3795865 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3300
median	11000
Q3	35000
95-th percentile	275000
Maximum	5.3795865 × 10⁸
Range	5.3795864 × 10⁸
Interquartile range (IQR)	31700

Descriptive statistics

Standard deviation	3630376.9
Coefficient of variation (CV)	21.480267
Kurtosis	8911.3386
Mean	169009.86
Median Absolute Deviation (MAD)	10000
Skewness	80.264355
Sum	2.7183884 × 10¹⁰
Variance	1.3179636 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	17014	8.6%
10000	6695	3.4%
5000	6437	3.2%
20000	5702	2.9%
15000	4779	2.4%
30000	3939	2.0%
25000	3599	1.8%
3000	3569	1.8%
50000	3345	1.7%
2000	3203	1.6%
Other values (11385)	102560	51.6%
(Missing)	38068	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	17014	8.6%
2	1	< 0.1%
4	2	< 0.1%
5	3	< 0.1%
10	11	< 0.1%
20	5	< 0.1%
25	7	< 0.1%
30	3	< 0.1%
35	1	< 0.1%
40	1	< 0.1%

Value	Count	Frequency (%)
537958646	1	< 0.1%
520000000	1	< 0.1%
400000000	2	< 0.1%
340000000	1	< 0.1%
272000000	1	< 0.1%
270000000	1	< 0.1%
239000000	1	< 0.1%
210000000	1	< 0.1%
175000000	1	< 0.1%
167000000	2	< 0.1%

Revised Cost
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	12629
Distinct (%)	6.5%
Missing	6066
Missing (%)	3.0%
Infinite	0
Infinite (%)	0.0%
Mean	132901.75

Minimum	0
Maximum	7.805 × 10⁸
Zeros	8514
Zeros (%)	4.3%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	7000
Q3	28715
95-th percentile	227340
Maximum	7.805 × 10⁸
Range	7.805 × 10⁸
Interquartile range (IQR)	28714

Descriptive statistics

Standard deviation	3584878.7
Coefficient of variation (CV)	26.973901
Kurtosis	17049.467
Mean	132901.75
Median Absolute Deviation (MAD)	6999
Skewness	108.7016
Sum	2.5629306 × 10¹⁰
Variance	1.2851355 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	47229	23.7%
0	8514	4.3%
10000	5474	2.8%
5000	5453	2.7%
20000	4696	2.4%
15000	4001	2.0%
30000	3291	1.7%
25000	3135	1.6%
3000	3067	1.5%
2000	2955	1.5%
Other values (12619)	105029	52.8%
(Missing)	6066	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8514	4.3%
0.01	1	< 0.1%
1	47229	23.7%
1.2	1	< 0.1%
2	4	< 0.1%
5	3	< 0.1%
10	11	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
14	6	< 0.1%

Value	Count	Frequency (%)
780500000	1	< 0.1%
520000000	1	< 0.1%
400000000	2	< 0.1%
336200000	1	< 0.1%
270000000	1	< 0.1%
266061486	1	< 0.1%
239000000	1	< 0.1%
210000000	1	< 0.1%
207680000	1	< 0.1%
200000000	4	< 0.1%

Existing Use
Text

MISSING

Distinct	93
Distinct (%)	0.1%
Missing	41117
Missing (%)	20.7%
Memory size	11.8 MiB

Length

Max length	20
Median length	19
Mean length	13.170286
Min length	4

Characters and Unicode

Total characters	2078179
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	apartments
2nd row	apartments
3rd row	2 family dwelling
4th row	2 family dwelling
5th row	1 family dwelling

Value	Count	Frequency (%)
family	67756	21.4%
dwelling	67756	21.4%
1	46768	14.8%
apartments	40800	12.9%
office	24617	7.8%
2	20988	6.6%
sales	7032	2.2%
retail	6910	2.2%
hndlng	4886	1.5%
food/beverage	4886	1.5%
Other values (144)	24040	7.6%

Most occurring characters

Value	Count	Frequency (%)
l	235150	11.3%
a	181738	8.7%
i	179803	8.7%
e	177532	8.5%
	158646	7.6%
n	129792	6.2%
f	123927	6.0%
m	113200	5.4%
t	108688	5.2%
d	81432	3.9%
Other values (29)	588271	28.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2078179	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	235150	11.3%
a	181738	8.7%
i	179803	8.7%
e	177532	8.5%
	158646	7.6%
n	129792	6.2%
f	123927	6.0%
m	113200	5.4%
t	108688	5.2%
d	81432	3.9%
Other values (29)	588271	28.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2078179	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	235150	11.3%
a	181738	8.7%
i	179803	8.7%
e	177532	8.5%
	158646	7.6%
n	129792	6.2%
f	123927	6.0%
m	113200	5.4%
t	108688	5.2%
d	81432	3.9%
Other values (29)	588271	28.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2078179	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	235150	11.3%
a	181738	8.7%
i	179803	8.7%
e	177532	8.5%
	158646	7.6%
n	129792	6.2%
f	123927	6.0%
m	113200	5.4%
t	108688	5.2%
d	81432	3.9%
Other values (29)	588271	28.3%

Existing Units
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	348
Distinct (%)	0.2%
Missing	51543
Missing (%)	25.9%
Infinite	0
Infinite (%)	0.0%
Mean	15.666006

Minimum	0
Maximum	1907
Zeros	29135
Zeros (%)	14.6%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	4
95-th percentile	64
Maximum	1907
Range	1907
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	74.47512
Coefficient of variation (CV)	4.7539316
Kurtosis	238.3122
Mean	15.666006
Median Absolute Deviation (MAD)	1
Skewness	12.867436
Sum	2308652.3
Variance	5546.5435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	47347	23.8%
0	29135	14.6%
2	21805	11.0%
3	8616	4.3%
6	6066	3.0%
4	5364	2.7%
12	2535	1.3%
5	2347	1.2%
8	1728	0.9%
9	1188	0.6%
Other values (338)	21236	10.7%
(Missing)	51543	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29135	14.6%
0.3	1	< 0.1%
1	47347	23.8%
2	21805	11.0%
3	8616	4.3%
4	5364	2.7%
5	2347	1.2%
6	6066	3.0%
7	1172	0.6%
8	1728	0.9%

Value	Count	Frequency (%)
1907	44	< 0.1%
1732	8	< 0.1%
1500	51	< 0.1%
1499	1	< 0.1%
1186	51	< 0.1%
1010	2	< 0.1%
1005	21	< 0.1%
1004	2	< 0.1%
1000	1	< 0.1%
948	1	< 0.1%

Proposed Use
Text

MISSING

Distinct	94
Distinct (%)	0.1%
Missing	42441
Missing (%)	21.3%
Memory size	11.8 MiB

Length

Max length	20
Median length	19
Mean length	13.208827
Min length	4

Characters and Unicode

Total characters	2066772
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	apartments
2nd row	apartments
3rd row	2 family dwelling
4th row	2 family dwelling
5th row	1 family dwelling

Value	Count	Frequency (%)
family	68410	21.8%
dwelling	68410	21.8%
1	46348	14.8%
apartments	43035	13.7%
office	23963	7.7%
2	22062	7.0%
sales	5193	1.7%
retail	5079	1.6%
food/beverage	5053	1.6%
hndlng	5053	1.6%
Other values (146)	20614	6.6%

Most occurring characters

Value	Count	Frequency (%)
l	232125	11.2%
a	179985	8.7%
i	177628	8.6%
e	175966	8.5%
	156751	7.6%
n	130398	6.3%
f	123053	6.0%
m	116197	5.6%
t	107434	5.2%
d	82574	4.0%
Other values (29)	584661	28.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2066772	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	232125	11.2%
a	179985	8.7%
i	177628	8.6%
e	175966	8.5%
	156751	7.6%
n	130398	6.3%
f	123053	6.0%
m	116197	5.6%
t	107434	5.2%
d	82574	4.0%
Other values (29)	584661	28.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2066772	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	232125	11.2%
a	179985	8.7%
i	177628	8.6%
e	175966	8.5%
	156751	7.6%
n	130398	6.3%
f	123053	6.0%
m	116197	5.6%
t	107434	5.2%
d	82574	4.0%
Other values (29)	584661	28.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2066772	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	232125	11.2%
a	179985	8.7%
i	177628	8.6%
e	175966	8.5%
	156751	7.6%
n	130398	6.3%
f	123053	6.0%
m	116197	5.6%
t	107434	5.2%
d	82574	4.0%
Other values (29)	584661	28.3%

Proposed Units
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	368
Distinct (%)	0.2%
Missing	50915
Missing (%)	25.6%
Infinite	0
Infinite (%)	0.0%
Mean	16.510882

Minimum	0
Maximum	1911
Zeros	26885
Zeros (%)	13.5%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	70
Maximum	1911
Range	1911
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	75.218997
Coefficient of variation (CV)	4.5557225
Kurtosis	223.71262
Mean	16.510882
Median Absolute Deviation (MAD)	1
Skewness	12.330487
Sum	2443528
Variance	5657.8975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	46914	23.6%
0	26885	13.5%
2	22892	11.5%
3	9347	4.7%
6	5872	3.0%
4	5504	2.8%
12	2474	1.2%
5	2400	1.2%
8	1800	0.9%
7	1336	0.7%
Other values (358)	22571	11.3%
(Missing)	50915	25.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26885	13.5%
1	46914	23.6%
2	22892	11.5%
3	9347	4.7%
4	5504	2.8%
5	2400	1.2%
6	5872	3.0%
7	1336	0.7%
8	1800	0.9%
9	1270	0.6%

Value	Count	Frequency (%)
1911	1	< 0.1%
1907	43	< 0.1%
1732	8	< 0.1%
1500	48	< 0.1%
1499	1	< 0.1%
1199	1	< 0.1%
1186	47	< 0.1%
1014	4	< 0.1%
1010	2	< 0.1%
1005	17	< 0.1%

Plansets
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	37311
Missing (%)	18.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.274649

Minimum	0
Maximum	9000
Zeros	63247
Zeros (%)	31.8%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	2
95-th percentile	2
Maximum	9000
Range	9000
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	22.406792
Coefficient of variation (CV)	17.578794
Kurtosis	160982
Mean	1.274649
Median Absolute Deviation (MAD)	0
Skewness	400.84207
Sum	205982
Variance	502.06432
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	98093	49.3%
0	63247	31.8%
3	250	0.1%
4	3	< 0.1%
6	2	< 0.1%
1	2	< 0.1%
20	1	< 0.1%
9000	1	< 0.1%
(Missing)	37311	18.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	63247	31.8%
1	2	< 0.1%
2	98093	49.3%
3	250	0.1%
4	3	< 0.1%
6	2	< 0.1%
20	1	< 0.1%
9000	1	< 0.1%

Value	Count	Frequency (%)
9000	1	< 0.1%
20	1	< 0.1%
6	2	< 0.1%
4	3	< 0.1%
3	250	0.1%
2	98093	49.3%
1	2	< 0.1%
0	63247	31.8%

TIDF Compliance
Text

MISSING

Distinct	2
Distinct (%)	100.0%
Missing	198908
Missing (%)	> 99.9%
Memory size	6.1 MiB

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	100.0%

Sample

1st row	P
2nd row	Y

Value	Count	Frequency (%)
p	1	50.0%
y	1	50.0%

Most occurring characters

Value	Count	Frequency (%)
P	1	50.0%
Y	1	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	1	50.0%
Y	1	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	1	50.0%
Y	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	1	50.0%
Y	1	50.0%

Existing Construction Type
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	7
Distinct (%)	< 0.1%
Missing	43369
Missing (%)	21.8%
Infinite	0
Infinite (%)	0.0%
Mean	4.7156312

Minimum	-99999
Maximum	99999
Zeros	0
Zeros (%)	0.0%
Negative	2
Negative (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	-99999
5-th percentile	1
Q1	3
median	5
Q3	5
95-th percentile	5
Maximum	99999
Range	199998
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	566.96662
Coefficient of variation (CV)	120.23133
Kurtosis	31105.634
Mean	4.7156312
Median Absolute Deviation (MAD)	0
Skewness	35.250938
Sum	733474
Variance	321451.15
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
5	113350	57.0%
1	28073	14.1%
3	9664	4.9%
2	4068	2.0%
4	381	0.2%
99999	3	< 0.1%
-99999	2	< 0.1%
(Missing)	43369	21.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99999	2	< 0.1%
1	28073	14.1%
2	4068	2.0%
3	9664	4.9%
4	381	0.2%
5	113350	57.0%
99999	3	< 0.1%

Value	Count	Frequency (%)
99999	3	< 0.1%
5	113350	57.0%
4	381	0.2%
3	9664	4.9%
2	4068	2.0%
1	28073	14.1%
-99999	2	< 0.1%

Existing Construction Type Description
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	43370
Missing (%)	21.8%
Memory size	13.1 MiB

wood frame (5)	113350
constr type 1	28072
constr type 3	9663
constr type 2	4068
constr type 4	381
Other values (3)	6

Length

Max length	16
Median length	14
Mean length	13.728854
Min length	13

Characters and Unicode

Total characters	2135386
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	wood frame (5)
2nd row	wood frame (5)
3rd row	wood frame (5)
4th row	wood frame (5)
5th row	wood frame (5)

Common Values

Value	Count	Frequency (%)
wood frame (5)	113350	57.0%
constr type 1	28072	14.1%
constr type 3	9663	4.9%
constr type 2	4068	2.0%
constr type 4	381	0.2%
wood frame (5)	4	< 0.1%
constr type 1	1	< 0.1%
constr type 3	1	< 0.1%
(Missing)	43370	21.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wood	113354	24.3%
frame	113354	24.3%
5	113354	24.3%
constr	42186	9.0%
type	42186	9.0%
1	28073	6.0%
3	9664	2.1%
2	4068	0.9%
4	381	0.1%

Most occurring characters

Value	Count	Frequency (%)
	311092	14.6%
o	268894	12.6%
e	155540	7.3%
r	155540	7.3%
w	113354	5.3%
5	113354	5.3%
(	113354	5.3%
)	113354	5.3%
m	113354	5.3%
a	113354	5.3%
Other values (12)	564196	26.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2135386	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	311092	14.6%
o	268894	12.6%
e	155540	7.3%
r	155540	7.3%
w	113354	5.3%
5	113354	5.3%
(	113354	5.3%
)	113354	5.3%
m	113354	5.3%
a	113354	5.3%
Other values (12)	564196	26.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2135386	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	311092	14.6%
o	268894	12.6%
e	155540	7.3%
r	155540	7.3%
w	113354	5.3%
5	113354	5.3%
(	113354	5.3%
)	113354	5.3%
m	113354	5.3%
a	113354	5.3%
Other values (12)	564196	26.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2135386	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	311092	14.6%
o	268894	12.6%
e	155540	7.3%
r	155540	7.3%
w	113354	5.3%
5	113354	5.3%
(	113354	5.3%
)	113354	5.3%
m	113354	5.3%
a	113354	5.3%
Other values (12)	564196	26.4%

Proposed Construction Type
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	43165
Missing (%)	21.7%
Memory size	11.5 MiB

5.0	114386
1.0	27843
3.0	9361
2.0	3778
4.0	377

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	467235
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	5.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	114386	57.5%
1.0	27843	14.0%
3.0	9361	4.7%
2.0	3778	1.9%
4.0	377	0.2%
(Missing)	43165	21.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	114386	73.4%
1.0	27843	17.9%
3.0	9361	6.0%
2.0	3778	2.4%
4.0	377	0.2%

Most occurring characters

Value	Count	Frequency (%)
.	155745	33.3%
0	155745	33.3%
5	114386	24.5%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	467235	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	155745	33.3%
0	155745	33.3%
5	114386	24.5%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	467235	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	155745	33.3%
0	155745	33.3%
5	114386	24.5%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	467235	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	155745	33.3%
0	155745	33.3%
5	114386	24.5%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Proposed Construction Type Description
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	43165
Missing (%)	21.7%
Memory size	13.1 MiB

wood frame (5)	114386
constr type 1	27843
constr type 3	9361
constr type 2	3778
constr type 4	377

Length

Max length	14
Median length	14
Mean length	13.734444
Min length	13

Characters and Unicode

Total characters	2139071
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	wood frame (5)
2nd row	wood frame (5)
3rd row	wood frame (5)
4th row	wood frame (5)
5th row	wood frame (5)

Common Values

Value	Count	Frequency (%)
wood frame (5)	114386	57.5%
constr type 1	27843	14.0%
constr type 3	9361	4.7%
constr type 2	3778	1.9%
constr type 4	377	0.2%
(Missing)	43165	21.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wood	114386	24.5%
frame	114386	24.5%
5	114386	24.5%
constr	41359	8.9%
type	41359	8.9%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Most occurring characters

Value	Count	Frequency (%)
	311490	14.6%
o	270131	12.6%
e	155745	7.3%
r	155745	7.3%
w	114386	5.3%
5	114386	5.3%
(	114386	5.3%
)	114386	5.3%
m	114386	5.3%
a	114386	5.3%
Other values (12)	559644	26.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2139071	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	311490	14.6%
o	270131	12.6%
e	155745	7.3%
r	155745	7.3%
w	114386	5.3%
5	114386	5.3%
(	114386	5.3%
)	114386	5.3%
m	114386	5.3%
a	114386	5.3%
Other values (12)	559644	26.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2139071	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	311490	14.6%
o	270131	12.6%
e	155745	7.3%
r	155745	7.3%
w	114386	5.3%
5	114386	5.3%
(	114386	5.3%
)	114386	5.3%
m	114386	5.3%
a	114386	5.3%
Other values (12)	559644	26.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2139071	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	311490	14.6%
o	270131	12.6%
e	155745	7.3%
r	155745	7.3%
w	114386	5.3%
5	114386	5.3%
(	114386	5.3%
)	114386	5.3%
m	114386	5.3%
a	114386	5.3%
Other values (12)	559644	26.2%

Site Permit
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	193550
Missing (%)	97.3%
Memory size	388.6 KiB

True	5360
(Missing)	193550

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5360	2.7%
(Missing)	193550	97.3%

Supervisor District
Categorical

HIGH CORRELATION

Distinct	14
Distinct (%)	< 0.1%
Missing	1719
Missing (%)	0.9%
Memory size	11.0 MiB

3	28649
8	26761
2	25484
6	24797
5	19045
Other values (9)	72455

Length

Max length	6
Median length	1
Mean length	1.0968959
Min length	1

Characters and Unicode

Total characters	216298
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	8
2nd row	2
3rd row	9
4th row	1
5th row	9

Common Values

Value	Count	Frequency (%)
3	28649	14.4%
8	26761	13.5%
2	25484	12.8%
6	24797	12.5%
5	19045	9.6%
9	16362	8.2%
7	14365	7.2%
1	13039	6.6%
10	12153	6.1%
4	9592	4.8%
Other values (4)	6944	3.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
3	28649	14.5%
8	26761	13.6%
2	25484	12.9%
6	24797	12.6%
5	19045	9.7%
9	16362	8.3%
7	14365	7.3%
1	13039	6.6%
10	12153	6.2%
4	9592	4.9%
Other values (4)	6944	3.5%

Most occurring characters

Value	Count	Frequency (%)
1	39074	18.1%
3	28649	13.2%
8	26761	12.4%
2	25484	11.8%
6	24797	11.5%
5	19045	8.8%
9	16362	7.6%
7	14365	6.6%
0	12153	5.6%
4	9592	4.4%
Other values (10)	16	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	216298	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	39074	18.1%
3	28649	13.2%
8	26761	12.4%
2	25484	11.8%
6	24797	11.5%
5	19045	8.8%
9	16362	7.6%
7	14365	6.6%
0	12153	5.6%
4	9592	4.4%
Other values (10)	16	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	216298	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	39074	18.1%
3	28649	13.2%
8	26761	12.4%
2	25484	11.8%
6	24797	11.5%
5	19045	8.8%
9	16362	7.6%
7	14365	6.6%
0	12153	5.6%
4	9592	4.4%
Other values (10)	16	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	216298	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	39074	18.1%
3	28649	13.2%
8	26761	12.4%
2	25484	11.8%
6	24797	11.5%
5	19045	8.8%
9	16362	7.6%
7	14365	6.6%
0	12153	5.6%
4	9592	4.4%
Other values (10)	16	< 0.1%

Neighborhoods - Analysis Boundaries
Categorical

HIGH CORRELATION

Distinct	41
Distinct (%)	< 0.1%
Missing	1725
Missing (%)	0.9%
Memory size	13.6 MiB

Financial District/South Beach	21816
Mission	14682
Sunset/Parkside	10207
West of Twin Peaks	8740
Castro/Upper Market	8527
Other values (36)	133213

Length

Max length	30
Median length	18
Mean length	14.780977
Min length	6

Characters and Unicode

Total characters	2914587
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mission
2nd row	Pacific Heights
3rd row	Mission
4th row	Outer Richmond
5th row	Bernal Heights

Common Values

Value	Count	Frequency (%)
Financial District/South Beach	21816	11.0%
Mission	14682	7.4%
Sunset/Parkside	10207	5.1%
West of Twin Peaks	8740	4.4%
Castro/Upper Market	8527	4.3%
Pacific Heights	8508	4.3%
Marina	8244	4.1%
Outer Richmond	7855	3.9%
Noe Valley	7844	3.9%
South of Market	7573	3.8%
Other values (31)	93189	46.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
beach	25870	6.5%
financial	21816	5.5%
district/south	21816	5.5%
mission	19211	4.9%
heights	18661	4.7%
of	16313	4.1%
market	16100	4.1%
hill	15798	4.0%
valley	14233	3.6%
richmond	12313	3.1%
Other values (46)	212950	53.9%

Most occurring characters

Value	Count	Frequency (%)
i	281035	9.6%
e	234500	8.0%
a	203693	7.0%
n	198634	6.8%
	197896	6.8%
t	194569	6.7%
s	176846	6.1%
o	150144	5.2%
r	148187	5.1%
c	109199	3.7%
Other values (36)	1019884	35.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2914587	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	281035	9.6%
e	234500	8.0%
a	203693	7.0%
n	198634	6.8%
	197896	6.8%
t	194569	6.7%
s	176846	6.1%
o	150144	5.2%
r	148187	5.1%
c	109199	3.7%
Other values (36)	1019884	35.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2914587	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	281035	9.6%
e	234500	8.0%
a	203693	7.0%
n	198634	6.8%
	197896	6.8%
t	194569	6.7%
s	176846	6.1%
o	150144	5.2%
r	148187	5.1%
c	109199	3.7%
Other values (36)	1019884	35.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2914587	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	281035	9.6%
e	234500	8.0%
a	203693	7.0%
n	198634	6.8%
	197896	6.8%
t	194569	6.7%
s	176846	6.1%
o	150144	5.2%
r	148187	5.1%
c	109199	3.7%
Other values (36)	1019884	35.0%

Zipcode
Real number (ℝ)

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	1716
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	94115.501

Minimum	94102
Maximum	94158
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	94102
5-th percentile	94103
Q1	94109
median	94114
Q3	94122
95-th percentile	94133
Maximum	94158
Range	56
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	9.2701045
Coefficient of variation (CV)	9.8497107 × 10^-5
Kurtosis	1.2263383
Mean	94115.501
Median Absolute Deviation (MAD)	6
Skewness	0.85171252
Sum	1.8559012 × 10¹⁰
Variance	85.934838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
94110	17838	9.0%
94114	13404	6.7%
94117	11781	5.9%
94109	11348	5.7%
94103	10988	5.5%
94115	10095	5.1%
94118	9813	4.9%
94123	9515	4.8%
94122	8886	4.5%
94105	8628	4.3%
Other values (17)	84898	42.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
94102	7164	3.6%
94103	10988	5.5%
94104	4229	2.1%
94105	8628	4.3%
94107	7706	3.9%
94108	5321	2.7%
94109	11348	5.7%
94110	17838	9.0%
94111	5385	2.7%
94112	7898	4.0%

Value	Count	Frequency (%)
94158	1058	0.5%
94134	2983	1.5%
94133	7424	3.7%
94132	3507	1.8%
94131	7665	3.9%
94130	81	< 0.1%
94129	23	< 0.1%
94127	4993	2.5%
94124	5266	2.6%
94123	9515	4.8%

Location
Text

Distinct	57604
Distinct (%)	29.2%
Missing	1700
Missing (%)	0.9%
Memory size	18.3 MiB

Length

Max length	41
Median length	40
Mean length	40.044278
Min length	35

Characters and Unicode

Total characters	7897132
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26164 ?
Unique (%)	13.3%

Sample

1st row	(37.765906581390105, -122.42453043666066)
2nd row	(37.78788490521045, -122.43641930200963)
3rd row	(37.75241643936911, -122.40877419451499)
4th row	(37.77928233382438, -122.48608415176169)
5th row	(37.74224320174262, -122.41981352499106)

Value	Count	Frequency (%)
37.79226164705184	554	0.1%
122.4034859571375	554	0.1%
37.79294896659241	330	0.1%
122.39809861435491	330	0.1%
37.728556952954136	281	0.1%
122.47676641508518	281	0.1%
37.77523036414975	276	0.1%
122.4174703200545	276	0.1%
37.78977799888473	252	0.1%
122.40173648131338	252	0.1%
Other values (115177)	391034	99.1%

Most occurring characters

Value	Count	Frequency (%)
2	899264	11.4%
7	893479	11.3%
3	736584	9.3%
1	703929	8.9%
4	698318	8.8%
5	534319	6.8%
6	524243	6.6%
8	524195	6.6%
9	523487	6.6%
0	478844	6.1%
Other values (6)	1380470	17.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7897132	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	899264	11.4%
7	893479	11.3%
3	736584	9.3%
1	703929	8.9%
4	698318	8.8%
5	534319	6.8%
6	524243	6.6%
8	524195	6.6%
9	523487	6.6%
0	478844	6.1%
Other values (6)	1380470	17.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7897132	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	899264	11.4%
7	893479	11.3%
3	736584	9.3%
1	703929	8.9%
4	698318	8.8%
5	534319	6.8%
6	524243	6.6%
8	524195	6.6%
9	523487	6.6%
0	478844	6.1%
Other values (6)	1380470	17.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7897132	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	899264	11.4%
7	893479	11.3%
3	736584	9.3%
1	703929	8.9%
4	698318	8.8%
5	534319	6.8%
6	524243	6.6%
8	524195	6.6%
9	523487	6.6%
0	478844	6.1%
Other values (6)	1380470	17.5%

Record ID
Real number (ℝ)

Distinct	38347
Distinct (%)	19.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1620464 × 10¹²

Minimum	1.2935322 × 10¹⁰
Maximum	1.49834 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1.2935322 × 10¹⁰
5-th percentile	1.34534 × 10¹¹
Q1	1.30857 × 10¹²
median	1.37184 × 10¹²
Q3	1.435 × 10¹²
95-th percentile	1.4859055 × 10¹²
Maximum	1.49834 × 10¹²
Range	1.4854047 × 10¹²
Interquartile range (IQR)	1.2643 × 10¹¹

Descriptive statistics

Standard deviation	4.9182207 × 10¹¹
Coefficient of variation (CV)	0.42323788
Kurtosis	0.55165922
Mean	1.1620464 × 10¹²
Median Absolute Deviation (MAD)	6.322 × 10¹⁰
Skewness	-1.5726861
Sum	2.3114266 × 10¹⁷
Variance	2.4188895 × 10²³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.41585 × 10¹²	11	< 0.1%
1.34437 × 10¹²	11	< 0.1%
1.30223 × 10¹²	10	< 0.1%
1.44093 × 10¹²	10	< 0.1%
1.45828 × 10¹²	10	< 0.1%
1.45923 × 10¹²	10	< 0.1%
1.40362 × 10¹²	10	< 0.1%
1.39947 × 10¹²	10	< 0.1%
1.36825 × 10¹²	10	< 0.1%
1.36952 × 10¹²	10	< 0.1%
Other values (38337)	198808	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.29353215 × 10¹⁰	1	< 0.1%
1.295722223 × 10¹⁰	1	< 0.1%
1.296226196 × 10¹⁰	1	< 0.1%
1.296342101 × 10¹⁰	1	< 0.1%
1.296629102 × 10¹⁰	1	< 0.1%
1.297286249 × 10¹⁰	1	< 0.1%
1.297668221 × 10¹⁰	1	< 0.1%
1.297846157 × 10¹⁰	1	< 0.1%
1.298230162 × 10¹⁰	1	< 0.1%
1.298784182 × 10¹⁰	1	< 0.1%

Value	Count	Frequency (%)
1.49834 × 10¹²	7	< 0.1%
1.49833 × 10¹²	7	< 0.1%
1.49832 × 10¹²	7	< 0.1%
1.49831 × 10¹²	8	< 0.1%
1.4983 × 10¹²	8	< 0.1%
1.49829 × 10¹²	9	< 0.1%
1.49828 × 10¹²	7	< 0.1%
1.49827 × 10¹²	5	< 0.1%
1.49826 × 10¹²	5	< 0.1%
1.49825 × 10¹²	9	< 0.1%

Auto

Heatmap
Table

	Current Status	Estimated Cost	Existing Construction Type	Existing Construction Type Description	Existing Units	Neighborhoods - Analysis Boundaries	Number of Existing Stories	Number of Proposed Stories	Permit Type	Permit Type Definition	Plansets	Proposed Construction Type	Proposed Construction Type Description	Proposed Units	Record ID	Revised Cost	Street Number	Street Number Suffix	Street Suffix	Supervisor District	Unit	Zipcode
Current Status	1.000	0.015	0.000	0.028	0.000	0.039	0.023	0.023	0.135	0.103	0.000	0.032	0.032	0.002	0.106	0.015	0.018	0.173	0.026	0.027	0.000	0.027
Estimated Cost	0.015	1.000	-0.073	0.000	0.009	0.009	0.099	0.117	-0.208	0.149	0.259	0.021	0.021	0.008	0.025	0.884	-0.020	0.000	0.000	0.012	0.006	-0.030
Existing Construction Type	0.000	-0.073	1.000	0.000	0.263	0.000	-0.620	-0.624	0.006	0.000	-0.346	0.000	0.000	0.252	0.091	-0.081	0.221	1.000	0.000	0.000	-0.145	0.487
Existing Construction Type Description	0.028	0.000	0.000	1.000	0.115	0.326	0.307	0.311	0.070	0.401	0.000	0.994	0.994	0.115	0.085	0.000	0.094	0.073	0.111	0.269	0.118	0.248
Existing Units	0.000	0.009	0.263	0.115	1.000	0.131	0.185	0.168	0.005	0.007	-0.169	0.142	0.142	0.981	0.052	-0.004	0.167	0.000	0.063	0.082	0.438	0.049
Neighborhoods - Analysis Boundaries	0.039	0.009	0.000	0.326	0.131	1.000	0.275	0.278	0.093	0.071	0.000	0.426	0.426	0.132	0.368	0.008	0.322	0.224	0.211	0.780	0.120	0.770
Number of Existing Stories	0.023	0.099	-0.620	0.307	0.185	0.275	1.000	0.982	0.025	0.030	0.286	0.410	0.410	0.181	-0.109	0.099	-0.133	0.079	0.092	0.215	0.197	-0.411
Number of Proposed Stories	0.023	0.117	-0.624	0.311	0.168	0.278	0.982	1.000	-0.021	0.031	0.311	0.409	0.409	0.194	-0.106	0.110	-0.128	0.068	0.092	0.217	0.196	-0.413
Permit Type	0.135	-0.208	0.006	0.070	0.005	0.093	0.025	-0.021	1.000	1.000	-0.285	0.057	0.057	-0.069	-0.013	-0.243	-0.005	0.204	0.058	0.057	0.064	0.001
Permit Type Definition	0.103	0.149	0.000	0.401	0.007	0.071	0.030	0.031	1.000	1.000	0.000	0.049	0.049	0.015	0.023	0.162	0.015	0.204	0.044	0.043	0.000	0.043
Plansets	0.000	0.259	-0.346	0.000	-0.169	0.000	0.286	0.311	-0.285	0.000	1.000	0.000	0.000	-0.133	-0.015	0.233	-0.064	1.000	0.000	0.003	-0.189	-0.204
Proposed Construction Type	0.032	0.021	0.000	0.994	0.142	0.426	0.410	0.409	0.057	0.049	0.000	1.000	1.000	0.143	0.085	0.017	0.121	0.054	0.148	0.356	0.133	0.306
Proposed Construction Type Description	0.032	0.021	0.000	0.994	0.142	0.426	0.410	0.409	0.057	0.049	0.000	1.000	1.000	0.143	0.085	0.017	0.121	0.054	0.148	0.356	0.133	0.306
Proposed Units	0.002	0.008	0.252	0.115	0.981	0.132	0.181	0.194	-0.069	0.015	-0.133	0.143	0.143	1.000	0.053	-0.007	0.168	0.000	0.064	0.087	0.437	0.029
Record ID	0.106	0.025	0.091	0.085	0.052	0.368	-0.109	-0.106	-0.013	0.023	-0.015	0.085	0.085	0.053	1.000	-0.015	-0.023	0.284	0.094	0.378	-0.230	-0.003
Revised Cost	0.015	0.884	-0.081	0.000	-0.004	0.008	0.099	0.110	-0.243	0.162	0.233	0.017	0.017	-0.007	-0.015	1.000	-0.063	0.000	0.000	0.010	0.024	-0.029
Street Number	0.018	-0.020	0.221	0.094	0.167	0.322	-0.133	-0.128	-0.005	0.015	-0.064	0.121	0.121	0.168	-0.023	-0.063	1.000	0.104	0.119	0.240	-0.005	0.151
Street Number Suffix	0.173	0.000	1.000	0.073	0.000	0.224	0.079	0.068	0.204	0.204	1.000	0.054	0.054	0.000	0.284	0.000	0.104	1.000	0.078	0.198	0.000	0.195
Street Suffix	0.026	0.000	0.000	0.111	0.063	0.211	0.092	0.092	0.058	0.044	0.000	0.148	0.148	0.064	0.094	0.000	0.119	0.078	1.000	0.215	0.079	0.247
Supervisor District	0.027	0.012	0.000	0.269	0.082	0.780	0.215	0.217	0.057	0.043	0.003	0.356	0.356	0.087	0.378	0.010	0.240	0.198	0.215	1.000	0.065	0.537
Unit	0.000	0.006	-0.145	0.118	0.438	0.120	0.197	0.196	0.064	0.000	-0.189	0.133	0.133	0.437	-0.230	0.024	-0.005	0.000	0.079	0.065	1.000	-0.060
Zipcode	0.027	-0.030	0.487	0.248	0.049	0.770	-0.411	-0.413	0.001	0.043	-0.204	0.306	0.306	0.029	-0.003	-0.029	0.151	0.195	0.247	0.537	-0.060	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Number Suffix	Street Name	Street Suffix	Unit	Unit Suffix	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Structural Notification	Number of Existing Stories	Number of Proposed Stories	Voluntary Soft-Story Retrofit	Fire Only Permit	Permit Expiration Date	Estimated Cost	Revised Cost	Existing Use	Existing Units	Proposed Use	Proposed Units	Plansets	TIDF Compliance	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Site Permit	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID
0	M394467	8	otc alterations permit	5/15/2013	3751	172	300	0	03rD	St	NaN	NaN	street space	issued	5/15/2013	5/15/2013	5/15/2013	NaN	5/15/2013	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.304810e+12
1	2.01505E+11	8	otc alterations permit	5/22/2015	3556	6	328	A	gUeRrErO	St	NaN	NaN	remodel (e) bathroom, convert (e) bedrm into bed room and office, all work at ground floor, comply with complaint 200452633. items 3 & 4: existing furnaces to be used.	complete	12/18/2015	5/22/2015	6/10/2015	12/18/2015	6/10/2015	NaN	3.0	3.0	NaN	NaN	6/4/2016	18000.0	18000.0	apartments	3.0	apartments	3.0	2.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	8	Mission	94103.0	(37.765906581390105, -122.42453043666066)	1.382530e+12
2	M798247	8	otc alterations permit	6/16/2017	655	61	2426	A	pInE	St	NaN	NaN	street space permit	issued	6/16/2017	6/16/2017	6/16/2017	NaN	6/16/2017	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	Pacific Heights	94115.0	(37.78788490521045, -122.43641930200963)	1.467270e+12
3	2.01308E+11	8	otc alterations permit	8/16/2013	4267	29	2607	A	bRyAnT	St	NaN	NaN	comply with nov 200009226 and 200346303 remoe e non permitted shed at the rear for unit 2607a. remodel bath, kitchen, new bedroom . unit 2607: remodel bathroom, kitchen, new bedroom, and bath. new lighting and fixtures for both unit	complete	7/24/2014	8/16/2013	11/12/2013	7/24/2014	11/12/2013	NaN	2.0	2.0	NaN	NaN	11/7/2014	55000.0	80000.0	apartments	4.0	apartments	4.0	2.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	9	Mission	94110.0	(37.75241643936911, -122.40877419451499)	1.314500e+12
4	2.01307E+11	8	otc alterations permit	7/26/2013	1518	37	535	A	26tH	Av	0.0	NaN	replace 2 windows in bathroom not visible; no structural changes max u factor .40	complete	12/10/2013	7/26/2013	7/26/2013	12/10/2013	7/26/2013	NaN	2.0	2.0	NaN	NaN	7/21/2014	1988.0	1988.0	2 family dwelling	2.0	2 family dwelling	2.0	0.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	1	Outer Richmond	94121.0	(37.77928233382438, -122.48608415176169)	1.312290e+12
5	2.0161E+11	8	otc alterations permit	10/17/2016	5643	42	118	A	vIrGiNiA	Av	NaN	NaN	kitchen remodeling, replace existing cabinets with new units, intsll new sink, faucet, countertop, led lights, install new window, install wall ceiling insulation, drywall, painting. provide plumbing to island	issued	10/18/2016	10/17/2016	10/18/2016	NaN	10/18/2016	NaN	3.0	3.0	NaN	NaN	10/13/2017	8000.0	25000.0	2 family dwelling	2.0	2 family dwelling	2.0	0.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	9	Bernal Heights	94110.0	(37.74224320174262, -122.41981352499106)	1.441230e+12
6	2.01406E+11	8	otc alterations permit	6/11/2014	3647	6	1142	A	gUeRrErO	St	NaN	NaN	for administrative purposes. to issue certificate of occupancy for final inspection. ref#200302258249. permitted as 1142 guerrero st to be rectified as 1142 a guerrero st.	complete	5/27/2015	6/11/2014	6/11/2014	5/27/2015	6/11/2014	NaN	1.0	1.0	NaN	NaN	6/6/2015	1.0	1.0	1 family dwelling	1.0	1 family dwelling	1.0	0.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	8	Mission	94110.0	(37.752837734228955, -122.4233184555373)	1.344940e+12
7	M619107	8	otc alterations permit	9/1/2015	4143	45	2662	A	22nD	St	0.0	NaN	street space permit	issued	9/1/2015	9/1/2015	9/1/2015	NaN	9/1/2015	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	Mission	94110.0	(37.75630632321998, -122.4080145673593)	1.394150e+12
8	M748127	8	otc alterations permit	12/20/2016	1128	1	1139	A	sCoTt	St	NaN	NaN	street space permit	issued	12/20/2016	12/20/2016	12/20/2016	NaN	12/20/2016	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	Western Addition	94115.0	(37.78025155712736, -122.43783693425848)	1.447990e+12
9	2.01501E+11	8	otc alterations permit	1/30/2015	1838	014A	1499	A	15tH	Av	NaN	NaN	revise pa# 201411171643. change of address on permit. change to 1499a 15th ave.	complete	2/6/2015	1/30/2015	1/30/2015	2/6/2015	1/30/2015	NaN	2.0	2.0	NaN	NaN	1/25/2016	1.0	1.0	apartments	4.0	apartments	4.0	0.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	7	Inner Sunset	94122.0	(37.760154807972945, -122.4728804480781)	1.369530e+12

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Number Suffix	Street Name	Street Suffix	Unit	Unit Suffix	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Structural Notification	Number of Existing Stories	Number of Proposed Stories	Voluntary Soft-Story Retrofit	Fire Only Permit	Permit Expiration Date	Estimated Cost	Revised Cost	Existing Use	Existing Units	Proposed Use	Proposed Units	Plansets	TIDF Compliance	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Site Permit	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID
198900	2.01506E+11	8	otc alterations permit	6/2/2015	7101A	7	736	NaN	hUrOn	Av	NaN	NaN	reroofing	complete	3/11/2016	6/2/2015	6/2/2015	3/11/2016	6/2/2015	NaN	2.0	2.0	NaN	NaN	5/27/2016	6000.0	6000.0	1 family dwelling	1.0	1 family dwelling	1.0	0.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	11	Outer Mission	94112.0	(37.71192805393076, -122.4500944316179)	1.383550e+12
198901	M871027	8	otc alterations permit	12/28/2017	1870	23	1514	NaN	25tH	Av	NaN	NaN	street space	issued	12/28/2017	12/28/2017	12/28/2017	NaN	12/28/2017	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	Sunset/Parkside	94122.0	(37.75921574765919, -122.48300451049278)	1.492020e+12
198902	2.01609E+11	8	otc alterations permit	9/20/2016	2130A	006G	78	NaN	cRaGmOnT	Av	NaN	NaN	replace (e) tub with walk in tub, 20 amp circuit, gfci outlet	complete	9/28/2016	9/20/2016	9/20/2016	9/28/2016	9/20/2016	NaN	2.0	2.0	NaN	NaN	9/15/2017	17900.0	17900.0	1 family dwelling	1.0	1 family dwelling	1.0	0.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	7	Inner Sunset	94116.0	(37.74973733662819, -122.4671301493082)	1.438110e+12
198903	2.01407E+11	8	otc alterations permit	7/16/2014	2528	24	66	NaN	cReStLaKe	Dr	NaN	NaN	cut a door and a staircase for access to backyard.build deck next to staircase.	complete	1/23/2015	7/16/2014	10/28/2014	1/23/2015	10/28/2014	Y	2.0	2.0	NaN	NaN	10/23/2015	4500.0	6000.0	1 family dwelling	1.0	1 family dwelling	1.0	2.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	4	Sunset/Parkside	94132.0	(37.73542953855242, -122.48149902038024)	1.349090e+12
198904	M651047	8	otc alterations permit	12/30/2015	6176	8	342	NaN	hArKnEsS	Av	NaN	NaN	street space	issued	12/30/2015	12/30/2015	12/30/2015	NaN	12/30/2015	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	Visitacion Valley	94134.0	(37.71765127619624, -122.40342209330782)	1.407980e+12
198905	2.01604E+11	3	additions alterations or repairs	4/5/2016	7295	21	3251	NaN	20tH	Av	NaN	NaN	ti for space 129,130, 132 partitions, mep, shelving, stonestown mall. ab -56 compliance 2014-0627-9771	complete	11/22/2016	4/5/2016	7/18/2016	11/22/2016	7/18/2016	NaN	2.0	2.0	NaN	NaN	7/3/2019	325000.0	928009.2	retail sales	0.0	retail sales	0.0	2.0	NaN	2.0	constr type 2	2.0	constr type 2	NaN	7	Lakeshore	94132.0	(37.728556952954136, -122.47676641508518)	1.418500e+12
198906	2.0151E+11	8	otc alterations permit	10/27/2015	4009	001A	1919	NaN	mArIpOsA	St	NaN	NaN	install new 2" underground combination fire main. ref app#201402108156	issued	10/27/2015	10/27/2015	10/27/2015	NaN	10/27/2015	NaN	3.0	3.0	NaN	Y	10/21/2016	1200.0	9600.0	1 family dwelling	1.0	1 family dwelling	1.0	2.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	10	Potrero Hill	94107.0	(37.76328445631136, -122.40287014554292)	1.400890e+12
198907	2.01607E+11	8	otc alterations permit	7/29/2016	4262	20	1341	NaN	sAn bRuNo	Av	NaN	NaN	replace rotten wooden moldings in kind front stairs less than 50% replace	issued	7/29/2016	7/29/2016	7/29/2016	NaN	7/29/2016	NaN	2.0	2.0	NaN	NaN	7/24/2017	1900.0	1900.0	1 family dwelling	1.0	1 family dwelling	1.0	0.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	10	Mission	94110.0	(37.75260530951628, -122.40400191084352)	1.431900e+12
198908	2.01701E+11	8	otc alterations permit	1/6/2017	146	7	660	NaN	bRoAdWaY	NaN	NaN	NaN	revision to pa 2016-0926-8773; remove (e) storefront & doors, remove floor, ceiling & wall finishes for new. new storefront, (n) wall & ceiling finishes, (n) flooring with waterproofing in a (n) alcove. mep under pa#201503100377	issued	2/1/2017	1/6/2017	2/1/2017	NaN	2/1/2017	NaN	2.0	2.0	NaN	NaN	1/27/2018	1.0	1.0	retail sales	9.0	retail sales	9.0	2.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	3	Chinatown	94133.0	(37.79800446861674, -122.4080339831039)	1.449660e+12
198909	2.01604E+11	8	otc alterations permit	4/25/2016	3708	56	525	NaN	mArKeT	St	NaN	NaN	16th floor - (4) evacuation plans.	issued	4/25/2016	4/25/2016	4/25/2016	NaN	4/25/2016	NaN	38.0	38.0	NaN	Y	4/20/2017	1600.0	1600.0	office	0.0	office	0.0	2.0	NaN	1.0	constr type 1	1.0	constr type 1	NaN	6	Financial District/South Beach	94105.0	(37.79040639954478, -122.39927546096968)	1.420790e+12

Most frequently occurring

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Number Suffix	Street Name	Street Suffix	Unit	Unit Suffix	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Structural Notification	Number of Existing Stories	Number of Proposed Stories	Voluntary Soft-Story Retrofit	Fire Only Permit	Permit Expiration Date	Estimated Cost	Revised Cost	Existing Use	Existing Units	Proposed Use	Proposed Units	Plansets	TIDF Compliance	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Site Permit	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID	# duplicates
1	2.01302E+11	4	sign - erect	2/5/2013	14	1	250	NaN	bEaCh	St	NaN	NaN	to attach signs to existing awning	complete	9/18/2013	2/5/2013	2/5/2013	9/18/2013	2/5/2013	NaN	4.0	NaN	NaN	NaN	1/31/2014	10000.0	10000.0	retail sales	NaN	NaN	NaN	2.0	NaN	1.0	constr type 1	NaN	NaN	NaN	3	North Beach	94133.0	(37.80805300064998, -122.41324762431046)	1.295230e+12	4
59	2.01609E+11	4	sign - erect	9/21/2016	7295	21	3251	NaN	20tH	Av	NaN	NaN	victoria's secret wall mounted electrical single faced wall sign	issued	9/21/2016	9/21/2016	9/21/2016	NaN	9/21/2016	NaN	2.0	NaN	NaN	NaN	9/16/2017	2000.0	2000.0	retail sales	NaN	NaN	NaN	2.0	NaN	2.0	constr type 2	NaN	NaN	NaN	7	Lakeshore	94132.0	(37.728556952954136, -122.47676641508518)	1.438210e+12	4
78	2.01711E+11	4	sign - erect	11/27/2017	353	1	200	NaN	lArKiN	St	NaN	NaN	to erect one non-electric, non-illuminated, single faced, wall sign.	filed	11/27/2017	11/27/2017	NaN	NaN	NaN	NaN	4.0	NaN	NaN	NaN	NaN	3000.0	NaN	museum	0.0	NaN	NaN	2.0	NaN	1.0	constr type 1	NaN	NaN	NaN	6	Tenderloin	94102.0	(37.78021549250912, -122.41602577118189)	1.488290e+12	4
0	2.01302E+11	4	sign - erect	2/11/2013	3930A	2	2300	NaN	16tH	St	NaN	NaN	install one illuminated wall sign for "vitamin shoppe"	complete	6/26/2013	2/11/2013	2/28/2013	6/26/2013	2/28/2013	NaN	2.0	NaN	NaN	NaN	2/23/2014	2000.0	2000.0	retail sales	0.0	NaN	NaN	2.0	NaN	1.0	constr type 1	NaN	NaN	NaN	10	Mission	94103.0	(37.76660897553399, -122.40911776717232)	1.295810e+12	3
10	2.01309E+11	4	sign - erect	9/17/2013	1517	37	6333	NaN	gEaRy	Bl	NaN	NaN	erect electric sign	complete	11/19/2013	9/17/2013	9/17/2013	11/19/2013	9/17/2013	NaN	1.0	NaN	NaN	NaN	9/12/2014	6500.0	6500.0	retail sales	0.0	NaN	NaN	2.0	NaN	3.0	constr type 3	NaN	NaN	NaN	1	Outer Richmond	94121.0	(37.779635697353044, -122.48739021723274)	1.317860e+12	3
26	2.01404E+11	2	new construction wood frame	4/25/2014	6243	19	590	NaN	lElAnD	Av	NaN	NaN	to erect 3 stories, no basement, single family dwelling.	filed	4/25/2014	4/25/2014	NaN	NaN	NaN	NaN	NaN	3.0	NaN	NaN	NaN	350000.0	NaN	NaN	NaN	1 family dwelling	1.0	2.0	NaN	NaN	NaN	5.0	wood frame (5)	Y	10	Visitacion Valley	94134.0	(37.71511329299603, -122.41528882720623)	1.339820e+12	3
55	2.01608E+11	2	new construction wood frame	8/4/2016	5377	71	159	NaN	cHaRtEr oAk	Av	NaN	NaN	erect 3 story, no basement, single family dwelling.	filed	8/4/2016	8/4/2016	NaN	NaN	NaN	NaN	NaN	3.0	NaN	NaN	NaN	300000.0	NaN	NaN	NaN	1 family dwelling	1.0	2.0	NaN	NaN	NaN	5.0	wood frame (5)	Y	10	Bayview Hunters Point	94124.0	(37.73537008200893, -122.404282097856)	1.432500e+12	3
94	M602288	8	otc alterations permit	7/9/2015	1859A	11	40	NaN	lUrLiNe	St	NaN	NaN	NaN	issued	7/9/2015	7/9/2015	7/9/2015	NaN	7/9/2015	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	Inner Sunset	94122.0	(37.75941893593247, -122.47089493049447)	1.387960e+12	3
2	2.01302E+11	4	sign - erect	2/5/2013	14	1	250	NaN	bEaCh	St	NaN	NaN	to erect 3 blade signs with intergrated lighting, signs facing jefferson	complete	9/17/2013	2/5/2013	2/5/2013	9/17/2013	2/5/2013	NaN	4.0	NaN	NaN	NaN	1/31/2014	10000.0	10000.0	retail sales	0.0	NaN	NaN	2.0	NaN	1.0	constr type 1	NaN	NaN	NaN	3	North Beach	94133.0	(37.80805300064998, -122.41324762431046)	1.295290e+12	2
3	2.01302E+11	8	otc alterations permit	2/1/2013	6280	43	806	NaN	rUsSiA	Av	NaN	NaN	install shake vinyl siding on back of house only not visible from the street . no structural changes	complete	5/8/2013	2/1/2013	2/1/2013	5/8/2013	2/1/2013	NaN	3.0	3.0	NaN	NaN	1/27/2014	7935.0	7935.0	2 family dwelling	2.0	2 family dwelling	2.0	0.0	NaN	5.0	wood frame (5)	5.0	wood frame (5)	NaN	11	Excelsior	94112.0	(37.71823948380821, -122.43070649984861)	1.294940e+12	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories